<?
require_once("../config/dbconn.php");require_once("../config/powercls.php");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	
}
-->
</style>

<link href="images/skin.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="17" height="29" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
    <td width="935" height="29" valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
      <tr>
        <td height="31"><div class="titlebt">产品查询</div></td>
      </tr>
    </table></td>
    <td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
  </tr>
  <tr>
    <td height="71" valign="middle" background="images/mail_leftbg.gif">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9"><table width="100%" height="138" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="13" valign="top">&nbsp;</td>
      </tr>
      <tr>
        <td valign="top">
		<form id="form1" name="form1" method="post" action="product_lst.php?act=query">
		<table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td colspan="3"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="nowtable">
                <tr>
                  <td class="left_bt2">&nbsp;&nbsp;&nbsp;&nbsp;</td>
                </tr>
              </table></td>
            </tr>
            <tr>
              <td height="30" colspan="3">
			  
			  <table width="100%" height="120" border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td height="30" align="center" bgcolor="#FFFFFF" class="left_txt">分类</td>
                  <td height="30" bgcolor="#FFFFFF" class="left_txt"><select name="psortid">
                    <option value="">请选择</option>
                    <?
		$sql="select * from {$db_prefix}psort where 1 order by orders asc";
		$result=$db->query($sql);
		while($rs=$db->fetch_array($result)){
			echo "<option value='".$rs['id']."'";
			echo ">".str_repeat("------",$rs['depth']-1).$rs['flname']."</option>";
		}
		$db->free_result($result);
		?>
                  </select></td>
                  </tr>
                <tr>
                  <td height="30" align="center" bgcolor="#FFFFFF" class="left_txt">产品名</td>
                  <td height="30" bgcolor="#FFFFFF" class="left_txt"><input name="productname" type="text" id="productname" /></td>
                  </tr>
                <tr>
                  <td height="30" align="center" bgcolor="#FFFFFF" class="left_txt">市场价</td>
                  <td height="30" bgcolor="#FFFFFF" class="left_txt"><label>
                  <input name="scprice1" type="text" id="scprice1" size="5">
                  -
                  <input name="scprice2" type="text" id="scprice2" size="5">
                  </label></td>
                </tr>
                <tr>
                  <td height="30" align="center" bgcolor="#FFFFFF" class="left_txt">价格</td>
                  <td height="30" bgcolor="#FFFFFF" class="left_txt"><label>
                  <input name="price1" type="text" id="price1" size="5">
-
<input name="price2" type="text" id="price2" size="5">
</label></td>
                </tr>
				   <tr>
                  <td height="30" align="center" bgcolor="#FFFFFF" class="left_txt">pv</td>
                  <td height="30" bgcolor="#FFFFFF" class="left_txt"><label>
                  <input name="pv1" type="text" id="pv1" size="5">
-
<input name="pv2" type="text" id="pv2" size="5">
</label></td>
                </tr>
              </table></td>
            </tr>
            
            <tr>
              <td height="30" colspan="3">&nbsp;</td>
            </tr>
            <tr>
              <td width="50%" height="30" align="right"><input type="submit" value="进行查询" name="B1" /></td>
              <td width="6%" height="30" align="right">&nbsp;</td>
              <td width="44%" height="30">&nbsp;</td>
            </tr>
            <tr>
              <td height="30" colspan="3">&nbsp;</td>
            </tr>
          </table>
		  </form>
		  </td>
      </tr>
    </table></td>
    <td background="images/mail_rightbg.gif">&nbsp;</td>
  </tr>
  <tr>
    <td valign="middle" background="images/mail_leftbg.gif"><img src="images/buttom_left2.gif" width="17" height="17" /></td>
      <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17" /></td>
    <td background="images/mail_rightbg.gif"><img src="images/buttom_right2.gif" width="16" height="17" /></td>
  </tr>
</table>

</body>
</html>